UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NmFDDBcnFh6+SIg444cQ/qjHc7yUgEVnWZIWNdLwGbY='
WHERE
key_id = '23478be12ef941a05a0d0d6dd1a560301e23f14a2cb0aa4eb9c5117179978233'
AND (
token = 'NmFDDBcnFh6+SIg444cQ/qjHc7yUgEVnWZIWNdLwGbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)