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