UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a3lADZBho88p6+1bfiRv36ezRJUDygxKfF64pNJkvlo='
WHERE
key_id = '3947e3e2782030a7a8f41bfdd5017973a3247de89c97c9c528228d58c548977a'
AND (
token = 'a3lADZBho88p6+1bfiRv36ezRJUDygxKfF64pNJkvlo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)