UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vLAh7A5Fnm9PsGTgRFLyCN8xQyKqWgdG62g472b5uIA='
WHERE
key_id = '7f9d5861cc5ac47690407a66f24686f84467387810a3c61e1930502a3aba52a3'
AND (
token = 'vLAh7A5Fnm9PsGTgRFLyCN8xQyKqWgdG62g472b5uIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)