UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPo/ZI4yHl9ZpX2iyiBLUZzTya90sJo6WCpD8QYm9iY='
WHERE
key_id = 'fae649760957bed68513f45cc151d8c8a219b8c18aa972da7d44c6f638592a3e'
AND (
token = 'sPo/ZI4yHl9ZpX2iyiBLUZzTya90sJo6WCpD8QYm9iY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)