UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVKdgw9es6uMI0sjahuRyaE9A0dHlhs8xnV/QHSWtsE='
WHERE
key_id = '46352aeb97695fad442c56a8b9a39ffe0f6610b590ec6e8067f820effcf0d228'
AND (
token = 'XVKdgw9es6uMI0sjahuRyaE9A0dHlhs8xnV/QHSWtsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)