UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8VF4CzuAh91IwEW4ZzfOnZH8ZvCwF5pezAaMEOoeIQ0='
WHERE
key_id = '2e036d5e15dc4e6ed2508363400123a327af8c80433b672b1f83b794f8eea6a2'
AND (
token = '8VF4CzuAh91IwEW4ZzfOnZH8ZvCwF5pezAaMEOoeIQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)