UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CLM23hniHyQ5lLBg1AYH0bJxLCVoORLrXPWmjSXURls='
WHERE
key_id = '4d6d25cc9c1a29ea1e32b98e885d97c319c5f332d5031fc9fdf0160a24a0df39'
AND (
token = 'CLM23hniHyQ5lLBg1AYH0bJxLCVoORLrXPWmjSXURls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)