UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ca+3UzU3JEY3jRNjeUd8P5CK56Zu5+3k3aMNa38VM+0='
WHERE
key_id = '2a1b74f37948c9b7a21bc8aa9c35004a295d20b509968cc5c3c2d28a930ddbc0'
AND (
token = 'ca+3UzU3JEY3jRNjeUd8P5CK56Zu5+3k3aMNa38VM+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)