UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jOiOjtDSOD+nmWXngcWKd/dFiz6y1ZjyOCP1xpnxS1g='
WHERE
key_id = 'ad9f3c488d1dd8300a514bf8b34c9666ae77fde6e1911e4d63944673a09ca0a6'
AND (
token = 'jOiOjtDSOD+nmWXngcWKd/dFiz6y1ZjyOCP1xpnxS1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)