UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6J2m8tmc0mXKSf5YyqNHizT8pzMNUJ0p3RWYiMl3x3Y='
WHERE
key_id = '2694c4f04e5779fe117b713eabce95bd6a14e1090291e48201c93a267851cc78'
AND (
token = '6J2m8tmc0mXKSf5YyqNHizT8pzMNUJ0p3RWYiMl3x3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)