UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCpGXvaWMS+z7R4Nop8+nefiCQXYsg8hsEBUcZNerNw='
WHERE
key_id = 'd4cf108f2451ea687cc2eff45d62a312e3d332b19e265e8f65f9e467cf187342'
AND (
token = 'VCpGXvaWMS+z7R4Nop8+nefiCQXYsg8hsEBUcZNerNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)