UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kcZhYUyp6yGNsZtCMqRuCPM4+8TCGznMq6maGrM+5U='
WHERE
key_id = '49bb62634f432bcb97b262ab30c3bcf8112d5b81435ee27e3763711d00f19788'
AND (
token = '0kcZhYUyp6yGNsZtCMqRuCPM4+8TCGznMq6maGrM+5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)