UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kVVdQx0WwKyPm8gYnALGHeYRZlcjLSFi2dyRytdi9nA='
WHERE
key_id = '477dac8a5de111bf05ccec5c53c12b18479b315ca56811840a9ac04742a2874e'
AND (
token = 'kVVdQx0WwKyPm8gYnALGHeYRZlcjLSFi2dyRytdi9nA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)