UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yKJs0KQpDbgSzRlFkV0VFC00Zjh3ElBEWB/GilY2Fa8='
WHERE
key_id = '840ba3f3597bd3c17c4728d0c0ede2b75d178004a119cab777b55cb5ea4d9810'
AND (
token = 'yKJs0KQpDbgSzRlFkV0VFC00Zjh3ElBEWB/GilY2Fa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)