UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'soxAosK4Jpi1I4MKmC63BcI0ZTa7BuOHS9k8ARJOFa4='
WHERE
key_id = 'fd30b3c355b0248d78d5bce87c11208dadcf7372d3d05cd36bb5da940b3af681'
AND (
token = 'soxAosK4Jpi1I4MKmC63BcI0ZTa7BuOHS9k8ARJOFa4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)