UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HsN0qotQKPPq5cf96y/Vg0rykrJfvz0s9qztuF9tZC4='
WHERE
key_id = 'aaadba4400d3de4fc871cea533440380d80773b4c1e1de731e9febfcaa9be5de'
AND (
token = 'HsN0qotQKPPq5cf96y/Vg0rykrJfvz0s9qztuF9tZC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)