UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQkg5voPsSypiHVB68nlKlxiK8iYE8X5EFHd0OiScAg='
WHERE
key_id = 'cabd29217d0279c390908a7b8ea39a621ac37af5dce65ec6afbc7a0884593352'
AND (
token = 'LQkg5voPsSypiHVB68nlKlxiK8iYE8X5EFHd0OiScAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)