UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3RaV7yTbeXLwOoCaAl6tsjJ6Q9Sha8DLfghME78jkkU='
WHERE
key_id = 'e848cd8b0e66aede995094fa79a8080af302e3dded001bc9319d1c086cfdf214'
AND (
token = '3RaV7yTbeXLwOoCaAl6tsjJ6Q9Sha8DLfghME78jkkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)