UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T47RIV486JuQyfIS+jqDOj3bWNIKkvt4CFPEu1se3wI='
WHERE
key_id = '89ca6b6740a90340266f57296f11b46e508b41183faee815fe6768ad0e46edbb'
AND (
token = 'T47RIV486JuQyfIS+jqDOj3bWNIKkvt4CFPEu1se3wI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)