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