UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EpuRjdUxCSiWUvHS819cVLv/qbn2W+M+8K+kG862kLU='
WHERE
key_id = 'be4590125d8a16092a7bffede31eb6fae8aeccd355f2afc6863449a670eaced3'
AND (
token = 'EpuRjdUxCSiWUvHS819cVLv/qbn2W+M+8K+kG862kLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)