UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/dGgLjGUztiX0QfHtJC5BTCiOg9gxPM2Ix13QienLvU='
WHERE
key_id = '8166c6461c28827c20c40e972277a78dcadbb965eff15785726c00e1d0e747cd'
AND (
token = '/dGgLjGUztiX0QfHtJC5BTCiOg9gxPM2Ix13QienLvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)