UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tLpnqaRxGgDaLH15vEAqIkwkeH6gHGvtG0ypom27Lus='
WHERE
key_id = '512fac73a26321d453330b678c82d273b655e1eb4fecbee67522185aed700096'
AND (
token = 'tLpnqaRxGgDaLH15vEAqIkwkeH6gHGvtG0ypom27Lus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)