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