UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HZhm8H9xcPPwGhoT9o0t2wn0ZYXzX8IyzJndqs62gww='
WHERE
key_id = 'a4e8461afa05e3b1282453f9bb2afd2a4e551a76d9a4cd2fcb76369073e02097'
AND (
token = 'HZhm8H9xcPPwGhoT9o0t2wn0ZYXzX8IyzJndqs62gww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)