UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4mPl12mUuXn8aYhLgd9S99VytexIGAbn5GnenBjPLI0='
WHERE
key_id = '12160fabcae58c283ed573e7908fdd9aa11b500483fdbda1ab60310a2c41e8a3'
AND (
token = '4mPl12mUuXn8aYhLgd9S99VytexIGAbn5GnenBjPLI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)