UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tb4RvcW8Smsj+992Qf7j1C92gOFEmgvPdw8Q0GgNcq0='
WHERE
key_id = 'bc493f069a014a35ece6314f23a67f5f64cd02beef7d5b142867174f1a727e6a'
AND (
token = 'tb4RvcW8Smsj+992Qf7j1C92gOFEmgvPdw8Q0GgNcq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)