UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3VM0VbsbQGfyfgkp2ojBTGJjJhKU3TTA+nor9JVKS8M='
WHERE
key_id = 'ab9ef90d930382279d9be3a2698898864a770c53f170fc2b1b96c4de490ad3c9'
AND (
token = '3VM0VbsbQGfyfgkp2ojBTGJjJhKU3TTA+nor9JVKS8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)