UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JBXlD8Nl+OjIT2mzYCWy9bkAAMA6ShFF2gzDPd/pIww=' 
WHERE 
  key_id = 'd1cb589ba5f54f3739a38d203cded6cf68b6a9c9e42c7690f9a8a99eee753ffd' 
  AND (
    token = 'JBXlD8Nl+OjIT2mzYCWy9bkAAMA6ShFF2gzDPd/pIww=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00051