UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rgM9T3PWHBxaIO6d2l8/FZ9wJm52MglPYHv38k2HY3g='
WHERE
key_id = 'c7de7026af8486c4c8f83cfc8864b6f9579ef1df22a21918c97e00cf13982831'
AND (
token = 'rgM9T3PWHBxaIO6d2l8/FZ9wJm52MglPYHv38k2HY3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)