UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mxYqq2Ecf/6CwyWwcWfCy/RvgIlBcNyAO+LdBJCbl+4='
WHERE
key_id = 'c71b4187d0dc55b80ffb72ba79e95a4f0f2620d3cb5e4b9ef5f486c860948c54'
AND (
token = 'mxYqq2Ecf/6CwyWwcWfCy/RvgIlBcNyAO+LdBJCbl+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)