UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BNUDQXFHvgb0f4J16l+qy0kai1D9SyAIQSNwZc1saz8='
WHERE
key_id = 'f899b6921454e7c9764c16f9fafac2dcbecd983a384a7d7471b8127301db2487'
AND (
token = 'BNUDQXFHvgb0f4J16l+qy0kai1D9SyAIQSNwZc1saz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)