UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nN+Qlhq3jJZ3tRjh+AGMBEv0eTPO1op7vxvAK4PfW1w='
WHERE
key_id = 'a92f58bc3fa794e13f1b3ec6c8b6e82f871c25f79b9c7d7cb98774f923ae79d6'
AND (
token = 'nN+Qlhq3jJZ3tRjh+AGMBEv0eTPO1op7vxvAK4PfW1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)