UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2HcE8Ko2HnYn1n1h3tbaFZ63yo4Q98PHyEm9QFl1jMI='
WHERE
key_id = '1c41ca31174bc2c31567789f52ad1cae4585c5e1ef00aaed818ad81cc6562f96'
AND (
token = '2HcE8Ko2HnYn1n1h3tbaFZ63yo4Q98PHyEm9QFl1jMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)